module.exports = function (sequelize, DataTypes) {
    return sequelize.define(
        'association',
        {
            id: {
                type: DataTypes.INTEGER,
                primaryKey: true,
                autoIncrement: true,
                comment: '主键'
            },
            association_name: {
                type: DataTypes.STRING,
                field: 'association_name',
                comment: '协会名称'
            },
            createTime: {
                type: DataTypes.DATE,
                field: 'createTime',
                comment: '创建时间'
                
            },
            legalperson: {
                type: DataTypes.STRING,
                field: 'legalperson',
                comment: '协会名称'
            },
            officeAddress: {
                type: DataTypes.STRING,
                field: 'officeAddress',
                comment: '法人'
            },
            contactPerson: {
                type: DataTypes.STRING,
                field: 'contactPerson',
                comment: '联系人'
            },
            contactMobile: {
                type: DataTypes.STRING,
                field: 'contactMobile',
                comment: '联系电话'
            },   
            email: {
                type: DataTypes.STRING,
                field: 'email',
                comment: '邮箱'
            },  
            introduce: {
                type: DataTypes.STRING,
                field: 'introduce',
                comment: '协会简介'
            }, 
            auditOptions: {
                type: DataTypes.STRING,
                field: 'auditOptions',
                comment: '审核选项'
            }, 
            status: {
                type: DataTypes.STRING,
                field: 'status',
                comment: '协会状态',
                default:0
            }, 
            remark: {
                type: DataTypes.STRING,
                field: 'remark',
                comment: '备注'
            },
            frozenRemark: {
                type: DataTypes.STRING,
                field: 'frozenRemark',
                comment: '状态备注'
            },
            logo: {
                type: DataTypes.STRING,
                field: 'logo',
                comment: '协会logo'
            },
        }
    );
}